Forum Discussion

KamilRetkiewicz's avatar
KamilRetkiewicz
Icon for Helper I rankHelper I
1 year ago

Conditional measure

Hi Guys,   I have come across a rather interesting situation. I have a table in which I have an ACCOUNT column. It is mapped with the other table (name_entity column). In the matrix in the rows I ...
Need Help
Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
12 days ago

HI KamilRetkiewicz​ 

Please share sample data to work with.based on your measure, it looks like fomat function and divide issue.

AVG_CASH_PERCENT_BUD = VAR __CATEGORY = SELECTEDVALUE(AVG_CASH_ACT[CATEGORY]) RETURN IF(     __CATEGORY = "% of Cash Invested",     VAR __TotalAvgCash =         CALCULATE(             [AVG_CASH_BUD],             REMOVEFILTERS(AVG_CASH_ACT[CATEGORY]),             AVG_CASH_ACT[CATEGORY] = "Total Average Cash"         )     VAR __CashInvested =         CALCULATE(             [AVG_CASH_BUD],             REMOVEFILTERS(AVG_CASH_ACT[CATEGORY]),             AVG_CASH_ACT[CATEGORY] = "Cash Invested"         )     RETURN         FORMAT(DIVIDE(__CashInvested, __TotalAvgCash), "0%;(0%);-"),     [AVG_CASH_BUD] )
AVG_CASH_BUD = VAR __Category = MAX(AVG_CASH_ACT[CATEGORY]) VAR __BUD =     CALCULATE(         SUM(AVG_CASH_ACT[AMOUNT]),         AVG_CASH_ACT[SCENARIO] = "Budget"     ) VAR __BUD_YTD =     TOTALYTD(         CALCULATE(             SUM(AVG_CASH_ACT[AMOUNT]),             AVG_CASH_ACT[SCENARIO] = "Budget"         ),         'Calendar'[Date]     ) VAR __MONTH = SELECTEDVALUE('Calendar'[MonthNo]) RETURN     IF(         __Category IN {"Net Interest (Cumulative)", "Interest on debt", "Interest on deposits"},         __BUD,         DIVIDE(__BUD_YTD, __MONTH)     )

Please give kudos or mark it as solution once confirmed.

Regards,

Praful