Forum Discussion

Nausee's avatar
Nausee
Regular Visitor
2 years ago

Cross Level Calculation- Power BI

We are looking for a solution for one of the requirements in Power BI Report.   Requirement: We need to display the value from the highest level (L1) to the lowest level (L4) in a card visual, fo...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi lbendlin ,

Thanks for the quick response.

Hi Nausee ,

Please have a try.

DynamicValue = 
VAR IsL1Filtered = ISFILTERED('Table'[L1])
VAR IsL2Filtered = ISFILTERED('Table'[L2])
VAR IsL3Filtered = ISFILTERED('Table'[L3])
VAR IsL4Filtered = ISFILTERED('Table'[L4])
RETURN
IF(IsL1Filtered, SUM('Table'[ValueL1]),
    IF(IsL2Filtered, SUM('Table'[ValueL2]),
        IF(IsL3Filtered, SUM('Table'[ValueL3]),
            SUM('Table'[ValueL4])
        )
    )
)

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.