Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello, I have a problem with US electoral votes... when I click on Alabama, I have 0 votes for Democrats, which is OK :
When I click on Arizona, I have a blank (!) :
... and when I click on California, I have 55 (as expected) :
Why would such a problem occur ? I check my database many times...
Regards,
Louis
Hi @Louis66 ,
To help you I also need to see which columns you put into the KPI card as well as the measure definition if you built a mesaure
Best regards
Michael
Hello Michael,
It seems I have a more fundamental problem... see, when I click on Nebraska, in 2020, for example, it should display 39.2% in favor of Democrats. For some reasons, I can only display Min, Max, Average, Count... but not the 2020 value. Something is not right here. Maybe it is in my modeling...
Louis
Hi @Louis66,
what is your expected result? The first thing which comes in ym mind is that in your data model The Row for Arizona (Dimension table) does not match a value in your fact table (votes).
What is your expected result for Arizona and what does your measure look like?
If the expceted result is zero a solution could be that you put behind your formul "+ 0". But this only makes sense in specific constellations.
Can you please share your data model and the measures you are using in your chart?
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hello Michael,
My expected was 11 for Arizona :
26 out of States are OK, the other 24 show 'Blank'.
Louis
User | Count |
---|---|
92 | |
88 | |
88 | |
79 | |
49 |
User | Count |
---|---|
156 | |
145 | |
105 | |
72 | |
55 |