Forum Discussion
animebuff
Helper I
Helper Idax issue on months
left side visual is what by default we get in PBI what I need is left side visual without jan month because there is no data for jan month in fact table the logic I have written is if n...
animebuffHelper I
Helper Idanextian thanks for the reply,
but your logic will give correct results on month wise but if you drill down to region it will fail
bottom 2 ( 3 and 4 ) are based on the logic you gave
my expectation is I need to get 3rd (image) on month wise and 2rd (image) on region wise drill down
note: drill down done on nov month
danextian
Super User
Super UserYou can use ISINSCOPE to check whether a column is the level in a hierarchy of levels.
Measure02 =
VAR numerator =
CALCULATE (
DISTINCTCOUNT ( 'S rate'[success] ),
'S rate'[inclusion flag] = "Y"
)
VAR denominator =
DISTINCTCOUNT ( 'S rate'[success] )
VAR _pct =
DIVIDE ( numerator, denominator )
RETURN
IF ( ISINSCOPE ( region[region] ), _pct + 0, _pct )