The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone,
Could you help to understand the following behavior and how to deal with this:
I have a simple structure with one fact table and two dimensions with both direction relations:
And I have a report with two slicers from dimension tables (State Name and Client Name), and one slicer for test - ClientKey directly from the Fact table:
It is filtered by the 'Client Name' dimension slicer with Client = 5
When I added a simple measure to the fact table, for example M_Value = 10, the table is not filtered by StateKey, but Client Name slicer is still 5 and State Name slicer is filtered:
And when I check ClientKey directly from the Fact table it works as expected:
Don't understand why relations do not work between fact table and dimensions when I use measure.
In fact, I need the measure of BKFC total, to calculate further the percentage of BKFC to BKFC Total.
To calculate percent I use the next measure:
BKFCPercent = var bigTotal = SUMX(ALL(FactTable[StateKey]), CALCULATE(SUM(FactTable[BKFC]))) return divide(sum(FactTable[BKFC]), bigTotal)
But the table is not filtered by StateKey as well.
Have I missed something?
Thanks
Solved! Go to Solution.
Hi @Long,
You can try to use below formula to calculate with the slicer, it not affected with the static value measure.
BKFCPercent = var bigTotal = SUMX(ALLSELECTED(FactTable),[BKFC]) return divide(sum(FactTable[BKFC]), bigTotal)
Regards,
Xiaoxin Sheng
Hi @Long,
I build a simple sample to test, it works well on my side, can you share the reproduce sample to test?
Regards,
Xiaoxin Sheng
Sure, here is the test report with two pages, one with the measure column and one without: Test Report
Hi @Long,
Can you please provide the pbix file to test?
Regards,
Xiaoxin Sheng
Hi @Long,
You can try to use below formula to calculate with the slicer, it not affected with the static value measure.
BKFCPercent = var bigTotal = SUMX(ALLSELECTED(FactTable),[BKFC]) return divide(sum(FactTable[BKFC]), bigTotal)
Regards,
Xiaoxin Sheng
Sure, here is the test report with two pages, one with the measure column and one without:
It looks that both dimensions do not react on the table with measure column!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |