Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
{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 |
---|---|
102 | |
91 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |