The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Solved! Go to Solution.
hi @Gordonlilj
Thank you for oyur quick response i managed to solve it with:
Hi,
It looks like you have one to many brackets so try removing them like i have done below
DIVIDE(COUNT('Report'[SEQ]);CALCULATE(COUNT('Report'[SEQ]);FILTER('Report';'Report'[actual] = "Open"))
hi @Gordonlilj
Thank you for oyur quick response i managed to solve it with:
If i understand you correctly you want to show the measure as percentage then you could remove the *100 and go into the modeling tab and click on the percentage symbol. It will convert numbers such as 0.89 to 89%
If i understand you correctly you want to show the measure as percentage then you could remove the *100 and go into the modeling tab and click on the percentage symbol. It will convert numbers such as 0.89 to 89%
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |