Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |