Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
{FIXED [COUNTRY], [REGION], [ORDERDATE] : SUM (
IF [KPIGROSS] = 'Yes'
THEN 1
ELSE 0
END) }
Thank you so much. I really have no idea on how to convert.
This should be dependent on how you wish to display this measure.
Do you want it to be displayed in a matrix/table or in a card?
You can provide some sample picture of your desired output, and the data structure as well if you can, so people can better understand the question and answer that.
Thanks John for the reply. I just want to keep it as a calculated field which will then be used to calculate an aggregation of percentage KPIGross for each week. The aggregate percentage KPI gross will be displayed as a line in bar chart. Below is the screenshot from the tableau.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |