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.
I have a measure that divides two columns
the first is filtered by the slicer and the second is not filtered
Measure = MPAP (TOTALYTD ([TMJ TOTAL IMPORT]) / Total import (not filtered)
Hi @aziz,
I'm not clear what is your problem? Could you describe it in more details?
Do you have problems when you create the measure?
If it is convenient, could you share some data sample and your desired output so that we could help further on it?
Best Regards,
Cherry
in fact I have a column which is MPAP which has as formula TOTALYTD ([TMJ TOTAL IMPORT] it allows to calculate the sum of total import until the chosen date in the slicer.
and I have a second column that is TMJ Total import which is the sum TMJ Total import for the whole year
The idea is to compare the TMJ Total import on the chosen date in the slicer to the total TMJ of the year as a percentage
Measure = MPAP (TOTALYTD ([TMJ TOTAL IMPORT]) / Total import (not filtered)
Kind regards,
Aziz
Hi @aziz,
Could you share some data sample and your desired output so that we could help further on it?
Best Regards,
Cherry
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |