Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Working on a measure that calculated the month/month difference. I was able to pull one together that works but now the totals dont total correctly. Ive ran into this problem before but can never get the HASONEFILTER correct.
Here is the first measure:
Mo/Mo Diff =IF(CALCULATE(
[Sum of Census],
PARALLELPERIOD(
'Calendar'[Dates],
-1,
MONTH)
) = BLANK(),
BLANK(),
[Sum of Census]-CALCULATE(
[Sum of Census],
PARALLELPERIOD(
'Calendar'[Dates],
-1,
MONTH)
))
Second measure with the HASONEFILTER
Mo/Mo Diff FIX =IF(HASONEFILTER('Calendar'[Month]),
[Mo/Mo Diff],
SUMX(VALUES('Calendar'[Month]),
[Mo/Mo Diff]))
Hi @analyst312 ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
@analyst312 , what are trying to achieve here? Please provide some details
refer https://p3adaptive.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |