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.
Solved! Go to Solution.
You have not closed bracket of calculate.
Try this
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/91...
Hi @Anonymous ,
Thanks for your reply.
I currently have:
You have not closed bracket of calculate.
Try this
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/91...
Hi @Anonymous ,
Thankyou, it now accepts this.
I have both calculations next to each other in my matrix but the first divide displays all of the % as expected, but the new formula to filter out one of the rows, or display it as 0, displays blank on the whole column. Ive attached an image.
Would you have any idea why it displays like this?
Thanks again for your help with this
Liam
debug your measure.
First check which measure is showing blank in divide and why.
Check is there any value other than 471 also check data type of column. you add 471 in (""). Hence it is taking it as string. 471 only for int.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
check my blog here
https://community.powerbi.com/t5/Community-Blog/Connecting-to-a-Tabular-Model-Using-Power-BI/ba-p/91...
Thanks for your help with this @Anonymous . After playing around with the formatting its managed to show up as expected.
Thanks
Liam
User | Count |
---|---|
69 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |