Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have two tables
Dimension country column and business type column
Fact table country column, Sales amount and business type
I have given relationship from dim country column to fact country column.
I'm using business type in slicer
My issue is if I select anything in business type it should show total of sales amount.
I have used "ALL" Dax function but when I select something in slicer data is filtering. I can't use edit interactions.
What ever we select in slicer it should show total .Data should not change.
I can't remove relationship because it will effect other columns.
Could you please suggest me.
Thanks
try not using the SalesAmount column but a measure with such code:
AllAmount :=
CALCULATE(
SUM(TableName[SalesAmount]),
ALL()
)
@FreemanZ - I tried this but not working. Actually my issue is. ...
In Dim Business type we have values like A B C
In fact business type we have values like A B C
When ever we select A Or B it should show total of A B C.
When ever we select C we should get only C total.
Now when we select A it showing only A total instead of A B C. Please help me i stuck with these from two days
could you please provide some sample data and ideally with the expected result?
Hi @FreemanZ ,
Please find the below link for sample data and detailed requirement. https://drive.google.com/file/d/1IAc5Ux2R_0QbfBe_6EG2JlI_4nGtHRgv/view?usp=drivesdk
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
14 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
16 | |
13 |