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.
How can I create a measure to calculate 'PPV= (Sum of TRUE COL for June 2020)/(Sum of TRUE COL for June 2020+ Sum of FALSE COL for June 2020)'?. June 2020 is just an example. The formula needs to be applied to all the date/time and PPV should be different for different months and years. I need to visualize this calculated PPV to show changes every month and year.
Screenshot of the data below.
Solved! Go to Solution.
Hi @Anonymous ,
This formula is dynamic and should work for all periods selected (one month, several months, several years).
@Anonymous , Try a measure like this
divide(sum(Table[True Col]),sum(Table[True Col]) + sum(Table[False Col]))
For date filter better join to date filter an use that.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.
Hi @Anonymous ,
This formula is dynamic and should work for all periods selected (one month, several months, several years).
User | Count |
---|---|
54 | |
48 | |
19 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
27 | |
22 |