Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
{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.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |