Forum Discussion

ravitejaballa's avatar
ravitejaballa
Helper III
6 years ago
Solved

Count by Catagory

Hi,   I trying to get number of DeviceID for a each catagory (binLegendColumn). But it has to be for latest value for a given timestamp. As you can see below, i am able to fetch latest hours valu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.  i have solve it using measures only.

    Hope this helps.

ravitejaballa's avatar
ravitejaballa
Helper III
6 years ago

Ashish_Mathur

You are awesome!!

your measure worked for me.

Did small change to get latest available value in given time range.

TestMeasure = 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( deviceHours[DeviceID] ),
            "ABCD", CALCULATE (
                [LatestHours],
                CALCULATETABLE ( VALUES ( deviceHours[DeviceID] ) ),
                ALLSELECTED ()
            )
        ),
        COUNTROWS (
            FILTER (
                binMater,
                [ABCD] >= binMater[Lower bin legend]
                    && [ABCD] <= binMater[Upper bin legend]
            )
        ) > 0
    )
)

 

 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

You are welcome.