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.
I have a Clustered Column visual in which I am using 3 measures and NOTHING on Axis.
3 Measures are
Count of Orders
Count of Sales
Count of Returns
Based on the Amout selected on the slicer I am counting.
List Amt is my slicer
My calculation is almost same for these 3 measures. and my DAX is
Orders Count Dynamic =
VAR MinValue = MIN ( 'Fact - Orders'[ListAmt] )
VAR MaxValue = MAX ( 'Fact - Orders'[ListAmt] )
RETURN
CALCULATE (
DISTINCTCOUNT ('Fact - Orders'[OrderNum] ),
ALL ( 'Fact - Orders'[OrderNum] ),
'Fact - Orders'[Order Amt] >= MinValue,
'Fact - Orders'[Order Amt] <= MaxValue
)
When I select any one of these 3 measure, my data should filter accordingly.
Example: when I select the bar on the graph "Count of Orders" lets say the value is "51"
My table on the same report should filter the data to ONLY those 51 orders out of 3K orders listed on the table.
Hi,
IN your Table visual, drag the three measures to the Visual Level Filter section. If you only want to see those where No Of sales is 1, then apply that critera. In the screenshot below, you will see the result becomes 76. I also modified your measure to:
No Of Sales =
VAR Min_Value = MIN(Orders[Max of])
VAR Max_Value = MAX(Orders[Max of])
RETURN
CALCULATE(
DISTINCTCOUNT(Orders[Product ID]),FILTER(Orders,
Orders[Sales] >= Min_Value&&
Orders[Sales] <= Max_Value
))
Carry out the same change in the other measures as well. Now the question is why does this number not tally with 201 in the column chart. I am not sure of that. If you can describe your data, business question and expected result in more detail, i may be able to frame your desired solution.
Hi,
It will help if you show your data and the expected result.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |