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
if the reply is helpful--
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
]2
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"} )
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
if the reply is helpful--