Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
source Data:
T1 | |||
Catergory | Sub Category | Value | Date |
Equity | 98 | 16/8/2021 | |
Equity | Cash | 40 | 16/8/2021 |
Equity | Del | 50 | 16/8/2021 |
Comm | 80 | 16/8/2021 | |
Comm | CommFut | 36 | 16/8/2021 |
Comm | commopt | 67 | 16/8/2021 |
FNO | 75 | 16/8/2021 | |
FNO | Future | 45 | 16/8/2021 |
FNO | Option | 38 | 16/8/2021 |
Ouptut:-
First visual Bar chart
when i click on equity bar chart it should display in the second visual bar it should display like below:-
second visual bar chart:-
Solved! Go to Solution.
Hi @Anshenterprices ,
Based on my test, you can create the following measure
Measure =
IF (
HASONEVALUE ( 'Table'[Sub Category] ),
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( 'Table', [Sub Category] <> BLANK () )
),
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( 'Table', [Sub Category] = BLANK () )
)
)
Then create the following visual, right-click Equity and select Drill down
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anshenterprices ,
Based on my test, you can create the following measure
Measure =
IF (
HASONEVALUE ( 'Table'[Sub Category] ),
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( 'Table', [Sub Category] <> BLANK () )
),
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( 'Table', [Sub Category] = BLANK () )
)
)
Then create the following visual, right-click Equity and select Drill down
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anshenterprices , create first bar visual on Category.
Second on subcategory
And in second you can have measure like
if(isfiltered(Table[Category]), calculate(sum(Table[Value]) , not(isblank([subcategory ]))), blank())
@amitchandak its not an aggregate value .
T1 | |||
Catergory | Sub Category | Value | Date |
Equity | 98 | 16/8/2021 | |
Equity | Cash | 40 | 16/8/2021 |
Equity | Del | 50 | 16/8/2021 |
Comm | 80 | 16/8/2021 | |
Comm | CommFut | 36 | 16/8/2021 |
Comm | commopt | 67 | 16/8/2021 |
FNO | 75 | 16/8/2021 | |
FNO | Future | 45 | 16/8/2021 |
FNO | Option | 38 | 16/8/2021 |
First Visual
second visual:- showing empty
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |