Forum Discussion
Tableau to DAX help
I am trying to convert some dashboards that are in Tableau over to Power BI. I am still learning DAX functionalities but how would I convert the below calculated field to a DAX query? SUM({ INCL...
yohanp17190 , check if , this approch can help
LOD Include (Level Of Details): https://youtu.be/nmBVc2fN6aU
Use countx in this case with filter
example
CALCULATE(
COUNTX(VALUES('Table'[Quarter]), [Quarter]),
FILTER(
ALL('Table'),
[Quarter] < ( "18-Q4") &&
[TotalInteractionNumber] <> "LEAD000001CH000001" &&
[HoldFlag] = 1 &&
[ActiveCampaignFlag] = 1
)
)