POWER BI VARIABLE RETURN BLANK

Anonymous
2021-11-07T17:26:18.91+00:00

Dear Community,
I'm using variable to have in a single measure informations to display in the visualization (Matrix or Table) but for for variables that refer to mesures resulting from calculation of other measures, the variable displays blank.

![147065-image.png]2147142-capture.png

TFRSummaryItems =   
                VAR REFOHADA = SELECTEDVALUE(OhadaIsStructure[CodeOhada])  
                RETURN  

                SWITCH(TRUE(),  

                REFOHADA = "XB", [ChiffredAffaire],  

                CALCULATE([BalanceAmount],  
                FILTER(OhadaIsStructure, OhadaIsStructure[CodeOhada]=REFOHADA)))  

For example, here, CHIFFRE D'AFFAIRES (A+B+C+D) measure [ChiffredAffaire] sould return 4 888 704.07 but in the visual is blank.

If i use the measure ChiffreDaffaire in the visualization "Card" i have the expected amount 4 88 704.07 as we can see in the picture above.

The measure ChiffredAffaire Formula is below :

ChiffredAffaire =   
CALCULATE(  
    [BalanceAmount],  
    OhadaIsStructure[CodeOhada] IN {"TB", "TC", "TD"} )  
Community Center | Not monitored
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2021-11-07T18:16:27.663+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.