Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
My datamodel is a typical multiple questionare model with bothways joins for all the dimensions with one Fact having each surveyId once and then the dimensions can have the several answers for every question (the model is described in here several threads):
I was asked to show percentage of total, for this question:
Where 'Ukendt' (=Unknown) is removed. That's when the trouble started 😞
I normally would use this measure to create a grand total:
Diagnose andel = DIVIDE (
[Antal respondenter],
CALCULATE ( [Antal respondenter], ALLSELECTED(DimDiagnose[Hvilken diagnose havde personen?]))
)
But the total is wrong:
I removed other answers in the table, but the chart for the same answers show the same amount. But the total is wrong as can be seen. I can create this pie chart:
And the percentage is correct, but I would prefer the stack chart and that I could calculate the total myself. What am I missing?
Solved! Go to Solution.
Hi @Bokazoit ,
For this you need to create a measure that calculates the total value best option is that measure is a new one so you can easily debug and reuse it.
Try the following code:
Total Value = SUMX(Values(Table[Hvorfor var samtalerne ikke laenger?]),[Your Metric])
If you need this to be used in several metrics you must create a calculation item.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Bokazoit ,
For this you need to create a measure that calculates the total value best option is that measure is a new one so you can easily debug and reuse it.
Try the following code:
Total Value = SUMX(Values(Table[Hvorfor var samtalerne ikke laenger?]),[Your Metric])
If you need this to be used in several metrics you must create a calculation item.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsTx that did the trick 🙂
Total Value =
DIVIDE([Antal samtaler],
CALCULATE(
SUMX(Values('DimSamtaleLængde'[Hvorfor var samtalerne ikke længere?]),[Antal samtaler]),
ALLSELECTED('DimSamtaleLængde'[Hvorfor var samtalerne ikke længere?])
)
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
110 | |
109 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |