Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have 4 level of hierarchy of data I am displaying as shown below:
From 2.Payer --> 4.PatientName, these data come from a same fact table.
What I am trying to do is, not showing any 4.PatientName if there is no match in those time periods.
So, if there is 0 for a lot of patients here, I do not want to display their patient names.
What is common way of handling this?
Thanks.
Solved! Go to Solution.
Hi @JustinDoh1
Just use filter of Decimalfix >0 .
I hope this might help!
Hi @JustinDoh1
Just use filter of Decimalfix >0 .
I hope this might help!
@Uzi2019 I found a solution using a measure called "Average" (that was used before a measure "decimalFix" was applied on the visual). The issue that I encountered was "decimalFix" is currently in a "Text" data type, so I could not use that as you indicated. But when I added the this conditon with "Average" on the visual, it worked out:
Thanks.
Hi @JustinDoh1
Or add blank filter also
Hi @JustinDoh1
Try this measure also
Measure = IF(SELECTEDVALUE('Table'[DecimalFix]) = "0.00" || SELECTEDVALUE('Table'[DecimalFix]) = BLANK(),0,1)
Apply his filter to visual
I hope this might be helpful.
I hope I answered your question!
The measure you are using most likely has a logic of either a) IF(ISBLANK(Sum or Count Expression), 0, (Sum or Count Expression)) or b) [Sum or Count Expression Measure] + 0.
To handle it just use a simple measure that doesn't add 0 or evaluates for blanks. You can also add a visual filter to remove the zeros like this:
Proud to be a Super User!
@ray_aramburo Thanks for help. Actually, I am just bring the "4.PatientName" from a column, not a measure. Should I create a measure for this column then?
The Patient Name is not the issue since it's the dimension, is the values field in the matrix you have to address (the one that produces 0 or the other desired quantities)
Proud to be a Super User!
@ray_aramburo Sorry. Can you please elaborate little bit? Regards to 'dimension', are you saying, I have to create a separate dataset for PatientName instead of using the value from this Fact table?
Hi! Sorry for the confusion! No, you don't have to separate it. Can you tell me which field do you have in Values? I'm assuming the PatientName is on the Rows.
Proud to be a Super User!
@ray_aramburo I wish I could create a sample PBIX file (maybe by tomorrow), but here is snapshot of rows, columns and values:
decimalFix is a measure:
decimalFix =
if(DISTINCTCOUNT(DimDate1[DateFormat])=1,
format([Average],"0"),
format([Average],"0.0")
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |