Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI DAX

I need to convert this Tableau fnction into dax..

Percentage diff = COUNTD([Completed Visits])/SUM([Fixed Visit Count])

fixed visit Count = 
{ FIXED YEAR ([START_DATE]),[FINANCIAL_CODE],[Region Breakdown],[PRIM_CODE]: COUNTD([VISIT_NO])}

i need to find this fixed visit count then i want to calculate percentage diff.

5 Replies