2

I have a table Feature_Site, I want to count the featureCode by FeatureStatusDescription, I already have a measure that gives me the feature count

Totl_features = 
COUNT ( Feature_Site[FeatureCode] )

I am struggling to write a measure that gives me the percentage of feature by the FeatureStatusDescription.

I am able to do this if I show value (Totl_features) as row total. The complication is I want a matrix table where total feature and percentage is in the row and the statuses are in the column.

see examples below enter image description here

The outcome should look like this enter image description here

I am using this

FeatureConditionMetric = DATATABLE(
    "Metric", STRING,
    {
        {"Num Features"},
        {"Percentage"}
    }
)

MetricValue = 
SWITCH(
    SELECTEDVALUE(FeatureConditionMetric[Metric]),
    "Num Features", [totl_features],
    "Percentage", [Percentage(%)],
    BLANK()
)

In my report, I have a page filter for designatedsiteflag = 1 and I have a slicer for the designatedsiteid which will allow me to filter the report

Here is my table result, you can see that the percentage is showing as 1 enter image description here

Improve this question
Related questions
0
Filtering a matrix in Power BI but not the rows
1
Power BI Slicer on Table 1 to calulate new column on other Table 2
0
How to get a measure of Average of column percentage using DAX in Power BI for column chart?
Load 3 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.